Database Table "hyp_Clients Website Ext. Record"
Table Description
Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Client Number | Integer | 0 | Edit | Hidden Read Only Key Field |
ClientNumber | |
| Account Status | Values List: 0 = Closed1 = Pending Approval 2 = Approved 3 = On Hold |
Status | 0 | Select | AccountStatus | |
| Send Password over | Values List: 0 = Email1 = SMS |
Status | 0 | Select | SendPasswordOver | |
| Last Registration Step | Integer | 0 | Edit | Read Only | LastRegistrationStep | |
| Registration Complete Until Step | Integer | 0 | Edit | Read Only | RegistrationCompleteUntilStep | |
| First Reg. Page Date | Date | 0 | SelectEdit | Read Only | FirstRegPageDate | |
| Registration Date | Date | 0 | SelectEdit | Read Only | RegistrationDate | |
| Agree to Terms Checkbox | Date | 0 | SelectEdit | Read Only | AgreeToTermsCheckbox | |
| Password Change Date | Date | 0 | SelectEdit | Read Only | PasswordChangeDate | |
| Last Sign-in Date | Date | 0 | SelectEdit | Read Only | LastSign-inDate | |
| Last Sign-in Details | String | 30 | SelectEdit | Read Only | LastSign-inDetails | |
| Last Quiz | String | 30 | SelectEdit | Read Only | LastQuiz | |
| Last Quiz Date | Date | 0 | SelectEdit | Read Only | LastQuizDate | |
| Last Doc Upload Date | Date | 0 | SelectEdit | Read Only | LastDocUploadDate | |
| Last Shopping Date | Date | 0 | SelectEdit | Read Only | LastShoppingDate | |
| Last Payment Date | Date | 0 | SelectEdit | Read Only | LastPaymentDate | |
| EMail Verification Status | Values List: 0 = Not Asked1 = Waiting 2 = Verified |
Status | 0 | Select | Read Only | EmailVerificationStatus |
| Phone Verification Status | Values List: 0 = Not Asked1 = Waiting 2 = Verified |
Status | 0 | Select | Read Only | PhoneVerificationStatus |
| Last Contract Signing at UTC | FixDT | 0 | SelectEdit | Read Only | LastContractSigningAtUtc | |
| Must Sign Contract (Again) | Bool | 0 | Select | MustSignContractAgain | ||
| EMail Token | String | 12 | Edit | Hidden Read Only |
EmailToken | |
| EMail Token at UTC | FixDT | 0 | SelectEdit | Hidden Read Only |
EmailTokenAtUtc | |
| Phone Token | String | 12 | Edit | Hidden Read Only |
PhoneToken | |
| Phone Token at UTC | FixDT | 0 | SelectEdit | Hidden Read Only |
PhoneTokenAtUtc | |
| Portal Password | String | 50 | Edit | Hidden Read Only |
PortalPassword | |
| API Password | String | 15 | Edit | Hidden Read Only |
ApiPassword | |
| Time Based OTP Token | String | 12 | Edit | Hidden Read Only |
TimeBasedOtpToken | |
| Time Based OTP Token at UTC | FixDT | 0 | SelectEdit | Hidden Read Only |
TimeBasedOtpTokenAtUtc | |
| PBX Token | Integer | 0 | Edit | Hidden Read Only |
PbxToken | |
| PBX Token at UTC | FixDT | 0 | SelectEdit | Hidden Read Only |
PbxTokenAtUtc |